Open topic with navigation

Time Spent

Time Spent iCube enables you to create ad hoc reports that help you analyze work items based on the time spent on working on it. Using the Time Spent iCube, Project Managers can analyze how much time was spent by a particular resource on a given work item. It also helps in tracking total time spent by individual resources across all work items.

Attributes

Expand this link to view the list of attributes available as part of the Time Spent iCube.

Attributes	Description
Assigned To	Name of the person to whom the work item is assigned.
Completed DateTime	Date and time when the work item was last closed, or was set to Closed status
Created DateTime	Date and time when the work item was created
Date	Date on which the time spent field was updated for a work item
Employee	Name of the employee
In Progress DateTime	Date and time when the work item first moved to the In Progress status category
Iteration	Iteration is the iteration in which the time spent was updated.
Multiple Assignment Flag	Indicates whether the work item has ever been assigned to more than one user
Priority	Priority of the work item
Project	Project to which the work item is associated
Reported By	Name of the user who reported the work item
Resolved DateTime	Date and time when the work item was resolved
Status	Status of the work item as mentioned in the source
Status Category	Current status category of the work item. Status category is a standardized set of statuses across workflows such as Proposed, In Progress, Resolved, and Completed
Story Points	Story points assigned to the work item. Story point is a standard method used by Agile teams to measure the difficulty or effort (in terms of man hours) involved in implementing a story by giving it points.
Time Spent	Amount of time spent on a work item as updated by the user
Time Spent Update DateTime	Date and time at which the Time Spent field was updated
Time Spent Updated By	User who last updated the Time Spent field on the work item
Total Time Spent Updates	Number of times the Time Spent field has been updated
Version	Fix Version to which the work item is associated
Work Item	Work Item refers to an issue that represents work to be completed. Work items can be of various types, such as task, enhancement, bug, epic, and so on
Work Item Number	Unique identifier for the work item
Work Item Type	Type of work item. For example, Epic, Story, Improvement, Bug, and so on

Metrics

Expand this link to view the list of metrics available as part of the Time Spent iCube.

Metric Name	Description	Formula	Expected Value
Avg Time Spent by Non-Assigned To	Average time spent on the work item by people who are not the assignees	Time spent by Non-assigned To (Hours)/Count of Non-assignees	NA
No. of Time Spent Updates	Number of times the Time Spent field was updated	Count([Count of Time Spent Updates])	NA
No. of Time Spent Updates by Assignee	Number of times the Time Spent field was updated by assignees	Count([Count of Time Spent Updates]) where Assignee flag= ‘Y’	NA
No. of Time Spent Updates by Non-Assignee	Number of times the Time Spent field was updated by non -assignees	Count([Count of Time Spent Updates]) where Assignee flag= ‘N’	NA
No. of Time Spent Updates by Reporter	Number of times the Time Spent field was updated by the person who reported the work item	Count([Count of Time Spent Updates]) where Reporter flag= ‘Y’	NA
Time Spent (Hours)	Total time spent on the work item	Sum(Time Spent Sec)/3600.0	NA
Time Spent by Assigned To (Hours)	Total time spent on the work item by assignees	Sum(Time Spent Sec)/3600.0 where Assignee flag= ‘Y’	NA
Time Spent by Non-Assigned To (Hours)	Total time spent on the work item by non-assignees	Sum(Time Spent Sec)/3600.0 where Assignee flag= ‘N’